/*
 *  SQLTools.h
 *  Stock_Pro
 *
 *  Created by imuse on 11-1-24.
 *  Copyright 2011 gaotime. All rights reserved.
 *
 */
#ifndef SQLTOOLS_H
#define SQLTOOLS_H

#include <sqlite3.h>

#define DATA_BASE		"gaotime.db"	/*数据库文件名*/

#define TABLE_QDIC		"qdic"			/*数据字典表名*/
#define	TABLE_PAY		"pay"			/*付费信息表名*/

/*数据字典表字段*/
#define FIELD_MARKETID	"marketid"		/*市场id*/
#define FIELD_TYPE		"type"			/*股票类型*/
#define FIELD_CODE		"code"			/*股票代码*/
#define FIELD_NAME		"name"			/*股票名称*/
#define FIELD_ABB		"abb"			/*股票拼音*/

#define FIELD_INDEX_MARKETID	0		//
#define FIELD_INDEX_TYPE		1		//
#define FIELD_INDEX_CODE		2		//
#define FIELD_INDEX_NAME		3		//
#define FIELD_INDEX_ABB			4		//

/*付费信息表字段*/
#define FIELD_PAY_INFO	"info"			/*付费信息*/

#define FIELD_INDEX_PAY_INFO	0		//

#endif
